﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Security;
using LibMS.Models;
using Dapper;

namespace LibMS.Filters
{
    public class LibMSMembershipProvider : MembershipProvider
    {
        public string ErrorMessage { get; set; }

        private readonly UnitOfWork _unitOfWork = new UnitOfWork();

        public override bool ValidateUser(string username, string password)
        {
            string message;
            var parameters = new DynamicParameters();
            parameters.Add("@UserName", username);
            parameters.Add("@Password", password);
            var result = _unitOfWork.CmsUser.QuerySpNT(out message, StringConstant.TABLE_CMSUSER + StringConstant.SP_CMSUSER_LOGIN, parameters);
            if (result == null)
            {
                ErrorMessage = message;
                return false;
            }
            else if (result.Count() == 0)
            {
                return false;
            }
            return true;
        }

        //public int? GetUserIdByUsername(string username, out string sqlMessage)
        //{
        //    var parameters = new DynamicParameters();
        //    parameters.Add("@UserName", username);
        //    parameters.Add("@UserId", dbType: System.Data.DbType.Int32, direction: System.Data.ParameterDirection.Output);
        //    _unitOfWork.CmsUser.QuerySpNT(out sqlMessage, StringConstant.TABLE_CMSUSER + StringConstant.SP_CMSUSER_GETUSERIDBYUSERNAME, parameters);
        //    return parameters.Get<int?>("@UserId");
        //}

#region Not Immplement Method

        //public override CreateAccount(string username, string password, int roleId, int? employeeId = null)
        //{
        //    throw new NotImplementedException();
        //}
        
        public override MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer,
                                                  bool isApproved, object providerUserKey, out MembershipCreateStatus status)
        {
            throw new NotImplementedException();
        }

        public override bool ChangePasswordQuestionAndAnswer(string username, string password, string newPasswordQuestion,
                                                             string newPasswordAnswer)
        {
            throw new NotImplementedException();
        }

        public override string GetPassword(string username, string answer)
        {
            throw new NotImplementedException();
        }

        public override bool ChangePassword(string username, string oldPassword, string newPassword)
        {
            throw new NotImplementedException();
        }

        public override string ResetPassword(string username, string answer)
        {
            throw new NotImplementedException();
        }

        public override void UpdateUser(MembershipUser user)
        {
            throw new NotImplementedException();
        }

        public override bool UnlockUser(string userName)
        {
            throw new NotImplementedException();
        }

        public override MembershipUser GetUser(object providerUserKey, bool userIsOnline)
        {
            throw new NotImplementedException();
        }

        public override MembershipUser GetUser(string username, bool userIsOnline)
        {
            throw new NotImplementedException();
        }

        public override string GetUserNameByEmail(string email)
        {
            throw new NotImplementedException();
        }

        public override bool DeleteUser(string username, bool deleteAllRelatedData)
        {
            throw new NotImplementedException();
        }

        public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords)
        {
            throw new NotImplementedException();
        }

        public override int GetNumberOfUsersOnline()
        {
            throw new NotImplementedException();
        }

        public override MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, out int totalRecords)
        {
            throw new NotImplementedException();
        }

        public override MembershipUserCollection FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, out int totalRecords)
        {
            throw new NotImplementedException();
        }

        public override bool EnablePasswordRetrieval
        {
            get { throw new NotImplementedException(); }
        }

        public override bool EnablePasswordReset
        {
            get { throw new NotImplementedException(); }
        }

        public override bool RequiresQuestionAndAnswer
        {
            get { throw new NotImplementedException(); }
        }

        public override string ApplicationName { get; set; }

        public override int MaxInvalidPasswordAttempts
        {
            get { throw new NotImplementedException(); }
        }

        public override int PasswordAttemptWindow
        {
            get { throw new NotImplementedException(); }
        }

        public override bool RequiresUniqueEmail
        {
            get { throw new NotImplementedException(); }
        }

        public override MembershipPasswordFormat PasswordFormat
        {
            get { throw new NotImplementedException(); }
        }

        public override int MinRequiredPasswordLength
        {
            get { throw new NotImplementedException(); }
        }

        public override int MinRequiredNonAlphanumericCharacters
        {
            get { throw new NotImplementedException(); }
        }

        public override string PasswordStrengthRegularExpression
        {
            get { throw new NotImplementedException(); }
        }

#endregion
    }
}